Tabela LReservationStatus

Definicja tabeli LReservationStatus

Name

LReservationStatus

Code

LReservationStatus

Comment

PL: Przyporzadkowanie kolejnych statusów rezerwacji
EN: Assignement following statuses to a reservation


Lista kolumn tabeli LReservationStatus

Name

Code

LReservationStatusID

LReservationStatusID

ReservationID

ReservationID

ReservationStatusID

ReservationStatusID

VisitCancelReasonID

VisitCancelReasonID

PersonID

PersonID

StartDT

StartDT

StopDT

StopDT

Comments

Comments

Active

Active


Kolumna LReservationStatusID tabeli LReservationStatus

Definicja kolumny LReservationStatusID tabeli LReservationStatus

Name

LReservationStatusID

Code

LReservationStatusID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ReservationID tabeli LReservationStatus

Definicja kolumny ReservationID tabeli LReservationStatus

Name

ReservationID

Code

ReservationID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ReservationStatusID tabeli LReservationStatus

Definicja kolumny ReservationStatusID tabeli LReservationStatus

Name

ReservationStatusID

Code

ReservationStatusID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna VisitCancelReasonID tabeli LReservationStatus

Definicja kolumny VisitCancelReasonID tabeli LReservationStatus

Name

VisitCancelReasonID

Code

VisitCancelReasonID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PersonID tabeli LReservationStatus

Definicja kolumny PersonID tabeli LReservationStatus

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna StartDT tabeli LReservationStatus

Definicja kolumny StartDT tabeli LReservationStatus

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

Yes

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli LReservationStatus

Definicja kolumny StopDT tabeli LReservationStatus

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna Comments tabeli LReservationStatus

Definicja kolumny Comments tabeli LReservationStatus

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna Active tabeli LReservationStatus

Definicja kolumny Active tabeli LReservationStatus

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Lista kluczy tabeli LReservationStatus

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LReservationStatus

Definicja klucza Identifier_1 tabeli LReservationStatus

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment